Version 2021 R2.3
Web Client Build Number: 10.2.3.88765
DataSync Build Number: 10.2.3.90719
May 18, 2022
Improvements
OLAP Manager
-
New columns have been added so that the user can see a cube's settings without having to select it. 4438
-
Cubes list : Description, Logging, Columnstore indexes, No null in sources.
-
Data Sources list: Dynamic, Active.
-
Dimensions list: Precision, Description.
-
Measures list: Summarizable.
-
DataSync
- The connection to DataSync is now validated before performing an extraction action to make sure the destination tables are properly updated (for example, when performing a Load All or Validate and Build action). 10785
- New connector for Sage 50 UK (Beta version). 7167
- New connector for Active Directory (Beta version). 10903
- New connector for LDAP / LDAPS (Beta version). 10543
- New connector for HubSpot (Beta version). 11370
- New connector for SAP HANA (Beta version). 11527
Web Client Templates
Template | Change description |
---|---|
Sage 200 Evolution | New Sage 200 Evolution template |
Fixes
Web Client
-
* Important * After searching for a Reporting Tree and adding nodes to it, Web Client would only save the Reporting Tree displayed on the screen when saving it. The other existing tree nodes were deleted. 11238
-
You could not save a dashboard under another name when there was no filtering panel. The Save As operation would return an error. 11123
-
An issue could sometimes happen when creating a worksheet with columns only and one of them contained Count Distinct Subtotal. (This error was displayed: The data array dataArray does not have the right dimension). 11177
-
When opening a Dashboard, the Date format in the Filtering Panel would not match the user's Date Format configured in the Regional Settings. 11151
-
When deleting a folder containing a Data Model or Report, an error message was displayed but the folder was correctly deleted. 11423
-
When exporting a report, the Subtotal Restrictions were displayed in the report. 11575
-
Saving KPI changes within a view or a dashboard caused all worksheet parameters to be reset to the default values. 11840
OLAP Manager
-
When services started a blank token was created, which could cause an issue with the OLAP memory. 10672
-
The content language for special variables was set to English instead of being set the ADMIN user's choice. 11076
Excel Add-in
-
A date with a custom format was not displayed in the Excel Add-in and the Data Model preview. 9472
-
An error could occur in Excel Add-in if the Date and Datetime fields had a NULL value when performing a data extraction. 11485
-
The Get & Transform Data and Queries & Connections features in the Excel Add-in would return an error. 11663
-
When creating a pivot and selecting the option Add this data to the Excel Data Model, the Excel Add-in would return an error if the Excel Data Model name started with C, c, R, r, or a digit. Make sure that the Data Model name adheres to this Microsoft Excel limitation; click here for details. 11165
-
When using Data Extractions or Formulas with the number format set to commas for decimal and the content language set to French, the distribution service would return an error. 11007
DataSync
-
DataSync log cleaning would cause performance issues. 11493
-
DataSync would not handle the maximum file size of the connection logs properly. This could result in large files taking a lot of disk space in the connections folder. 11077
-
Data could not be loaded into Sage Intacct tables. DataSync would encounter a mismatch error between cached data and real data. 11114
-
An error could occur when adding new tables or extractions for the Sage Business Cloud connector. 11407 REST API provider - ETNA